Example of Using SQLite Console

Basic SQLite query statements

sqlite> pragma database_list;
+---+------+------------------------------------------+
| 0 | main | /Users/siuha/Desktop/sqlite_table.sqlite |
+---+------+------------------------------------------+
1 rows in set (0.01 sec)

sqlite> select Description, Cost from parts where PartNo = 2619;
+--------------------+-------+
| Description        | Cost  |
+--------------------+-------+
| Navigation Compass | 9.177 |
+--------------------+-------+
1 rows in set (0.01 sec)

sqlite>